<?

//检查表格是否存在，不存在则插入
if(!check_table_is_exist($dbName,$table_Prefix."detail_relation"))
{
//如果不存在，应该需要sql新建一个数据表。才能兼容没有这个表的网站。

    $parameter['table']       = $table_Prefix."detail_relation";
    $parameter['custom_type'] = "int(11),int(11)";
    $parameter['custom_item'] = "goods_id,detail_id";
    $query = mysql_query(creat_table($parameter)) or die ("error:".mysql_error());

}

//检查表格是否存在，不存在则插入
if(!check_table_is_exist($dbName,$table_Prefix."brand_term_relation"))
{
//如果不存在，应该需要sql新建一个数据表。才能兼容没有这个表的网站。

    $parameter['table']       = $table_Prefix."brand_term_relation";
    $parameter['custom_type'] = "int(11),int(11)";
    $parameter['custom_item'] = "term_id,brand_id";
    $query = mysql_query(creat_table($parameter)) or die ("error:".mysql_error());

}
//检查表格是否存在，不存在则插入
if(!check_table_is_exist($dbName,$table_Prefix."goods_term_relation"))
{
//如果不存在，应该需要sql新建一个数据表。才能兼容没有这个表的网站。

    $parameter['table']       = $table_Prefix."goods_term_relation";
    $parameter['custom_type'] = "int(11),int(11),int(11)";
    $parameter['custom_item'] = "term_id,goods_id,product_id";
    $query = mysql_query(creat_table($parameter)) or die ("error:".mysql_error());

}


//检查表格是否存在，不存在则创建
if(!check_table_is_exist($dbName,$table_Prefix."search_log"))
{
//如果不存在，应该需要sql新建一个数据表。才能兼容没有这个表的网站。

    $parameter['table']       = $table_Prefix."search_log";
    $parameter['custom_type'] = "varchar(255)";
    $parameter['custom_item'] = "keywords";
    $query = mysql_query(creat_table($parameter)) or die ("error:".mysql_error());
}

if(!check_table_is_exist($dbName,$table_Prefix."sql_log"))
{
//如果不存在，应该需要sql新建一个数据表。才能兼容没有这个表的网站。

    $parameter['table']       = $table_Prefix."sql_log";
    $parameter['custom_type'] = "text";
    $parameter['custom_item'] = "sql_data";
    $query = mysql_query(creat_table($parameter)) or die ("error:".mysql_error());
}


if(!check_table_is_exist($dbName,$table_Prefix."deadline_img"))
{
//如果不存在，应该需要sql新建一个数据表。才能兼容没有这个表的网站。

    $parameter['table']       = $table_Prefix."deadline_img";
    $parameter['custom_type'] = "varchar(255),varchar(255)";
    $parameter['custom_item'] = "img_name,is_delete";
    $query = mysql_query(creat_table($parameter)) or die ("error:".mysql_error());
}

if(!check_table_is_exist($dbName,$table_Prefix."product_attr"))
{
//如果不存在，应该需要sql新建一个数据表。才能兼容没有这个表的网站。

    $parameter['table']       = $table_Prefix."product_attr";
    $parameter['custom_type'] = "varchar(255),varchar(255),varchar(255),varchar(255),int(11)";
    $parameter['custom_item'] = "img_title,img_desc,img_url,img_price , detail_nid";
    $query = mysql_query(creat_table($parameter)) or die ("error:".mysql_error());
}



if(!check_table_is_exist($dbName,$table_Prefix."sessions")){
	
	$sql ="CREATE TABLE ".$table_Prefix."sessions (
  `sesskey` char(32) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',
  `expiry` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `adminid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ip` char(15) NOT NULL DEFAULT '',
  `user_name` varchar(60) NOT NULL,
  `user_rank` tinyint(3) NOT NULL,
  `discount` decimal(3,2) NOT NULL,
  `email` varchar(60) NOT NULL,
  `data` char(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`sesskey`),
  KEY `expiry` (`expiry`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk";
	
	$query = mysql_query($sql) or die ("error:".mysql_error());

}


if(!check_table_is_exist($dbName,$table_Prefix."sessions_data")){
	
	$sql ="CREATE TABLE ".$table_Prefix."sessions_data (
  `sesskey` varchar(32) CHARACTER SET gbk COLLATE gbk_bin NOT NULL DEFAULT '',
  `expiry` int(10) unsigned NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  PRIMARY KEY (`sesskey`),
  KEY `expiry` (`expiry`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;";
	
	$query = mysql_query($sql) or die ("error:".mysql_error());
	
}


if(!check_table_is_exist($dbName,$table_Prefix."goods_order_info")){
	
	$sql ="CREATE TABLE ".$table_Prefix."goods_order_info (
  `order_id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `order_sn` varchar(255) NOT NULL COMMENT '订单号',
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `consignee` varchar(255) NOT NULL,
  `mobile_phone` varchar(255) NOT NULL,
  `user_address` varchar(255) NOT NULL COMMENT '用户地址',
  `order_state` varchar(20) NOT NULL DEFAULT '0' COMMENT '订单状态',
  `shipping_sn` varchar(255) NOT NULL COMMENT '发货单号',
  `shipping_name` varchar(50) NOT NULL COMMENT '快递名字',
  `remark` text NOT NULL COMMENT '备注',
  `add_time` int(11) NOT NULL,
  `total` varchar(255) NOT NULL,
  `rank_content` text NOT NULL,
  `deadline` int(11) NOT NULL,
  `order_state_stop` tinyint(2) NOT NULL DEFAULT '0',
  `is_update` tinyint(4) NOT NULL DEFAULT '0',
  `shipping_time` int(11) NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';";
	
	$query = mysql_query($sql) or die ("error:".mysql_error());
	
}

if(!check_table_is_exist($dbName,$table_Prefix."goods_order")){
	
	$sql ="CREATE TABLE ".$table_Prefix."goods_order (
		  `rec_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '索引ID',
		  `order_id` int(11) NOT NULL COMMENT '订单ID',
		  `goods_id` int(11) NOT NULL COMMENT '商品ID',
		  `goods_number` int(11) NOT NULL COMMENT '商品数量',
		  `goods_price` int(11) NOT NULL,
		  `return_goods_ship_name` varchar(255) NOT NULL COMMENT '退货快递公司',
		  `return_goods_ship_sn` varchar(255) NOT NULL COMMENT '退货快递单号',
		  `return_goods_type` int(10) NOT NULL DEFAULT '0' COMMENT '退货/退款类型',
		  `return_goods_answer` varchar(255) NOT NULL COMMENT '退货/退款原因',
		  `return_goods_remark` text NOT NULL COMMENT '退货/退款备注',
		  `goods_state` int(11) NOT NULL DEFAULT '0',
		  PRIMARY KEY (`rec_id`)
		) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='订单表的商品内容';";
	
	$query = mysql_query($sql) or die ("error:".mysql_error());
}


if(!check_table_is_exist($dbName,$table_Prefix."nav")){
	
	$sql ="CREATE TABLE ".$table_Prefix."nav (
		  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
		  `ctype` varchar(10) DEFAULT NULL,
		  `cid` smallint(5) unsigned DEFAULT NULL,
		  `name` varchar(255) NOT NULL,
		  `ifshow` tinyint(1) NOT NULL,
		  `vieworder` tinyint(1) NOT NULL,
		  `opennew` tinyint(1) NOT NULL,
		  `url` varchar(255) NOT NULL,
		  `type` varchar(10) NOT NULL,
		  `icon` varchar(255) NOT NULL,
		  PRIMARY KEY (`id`),
		  KEY `type` (`type`),
		  KEY `ifshow` (`ifshow`)
		) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
	
	
	$query = mysql_query($sql) or die ("error:".mysql_error());
}





//检查表格项目======================================
//+++++++++++++++++++++++++++++++++++++++++++++++++


//管理用户表。增加微信部分信息。用于推送信息
update_exists('`'.$dbName.'`.`'.$table_Prefix."login_admin`" , '`weixin_send`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."login_admin`" , '`open_id`' , 1);//检查表是否有这个字段  如果没有自动生
update_exists('`'.$dbName.'`.`'.$table_Prefix."login_admin`" , '`system`' , 1);//检查表是否有这个字段  如果没有自动生
update_exists('`'.$dbName.'`.`'.$table_Prefix."login_admin`" , '`status`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."login_admin`" , '`author`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."login_admin`" , '`ip`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."login_admin`" , '`modify_time`' , 1);



//网站表，增加服务器，域名到期等信息
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`hoststart`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`hostexpire`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`dominstart`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`dominexpire`' , 1);
//关键字
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`search_default`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`search_placeholder`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`show_hot_search`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`show_true_hot_search`' , 2);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`show_hot_search_number`' , 2);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`hot_search`' , 1);
//邮箱
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`smtp`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`smtp_server`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`smtp_server_port`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`smtp_user_mail`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`smtp_user`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`smtp_pass`' , 1);






//友情链接
update_exists('`'.$dbName.'`.`'.$table_Prefix."link`" , '`status`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."link`" , '`publish`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."link`" , '`listorder`' , 1);





//contact表

update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`contact_name`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`twitter`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`tumblr`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`pinterest`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`whatsapp`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`google`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`facebook`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`dycode`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`douyin_num`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."contact`" , '`wxvcode`' , 1);









//留言板


update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`content`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`title`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`gender`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`qq`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`msn`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`skype`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`source`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`icon`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`nickname`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`phone`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`mobile`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`zipcode`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`local`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`company`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`status`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`readtime`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."gbook`" , '`mark`' , 1);









//网站表，增加服务器，域名到期等信息

update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`en_name`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`chdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`spdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`jpdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`krdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`chwdomin`' , 1);

update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`m_subdomain`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`m_chdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`m_spdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`m_jpdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`m_krdomin`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`m_chwdomin`' , 1);

update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`video_file`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`logo2`' , 1);



update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`" , '`listorder`' , 1);


update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`danwei`' , 1);//计价单位
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`danwei2`' , 1);//计价单位
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`video`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`detail2`' , 3);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`detail3`' , 3);

update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`icon_alt`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`image6`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`image7`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`image8`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`image9`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`image10`' , 1);


update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`en_name`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`short_desc`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`introduce2`' , 3);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`introduce3`' , 3);

update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`favorite`' , 2);//检查表是否有这个字段  如果没有自动生

update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`neworder`' , 2);//检查表是否有这个字段  如果没有自动生


update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`erweima`' , 1);

update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`map_address`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`video_path`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`video_time`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`video_img`' , 4);

update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`video_path2`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`video_time2`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`video_img2`' , 4);





//下架时间，20220630
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`target`' , 4);
//banner的点击窗口在哪里打开，20220630
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`offshelves`' , 4);
//banner的展示次数 20220706
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`views`' , 2);

















//分类表
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`is_disabled`' , 2);

update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`en_name`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`search_name`' , 1);

update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`banner_title`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`banner_url`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`shop_brand`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`address`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`location`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`icon_alt`' , 1);


update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`" , '`link_menu`' , 1);

update_exists('`'.$dbName.'`.`'.$table_Prefix."threed`" , '`3d`' , 1);


update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`" , '`seo_term`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`", '`seo_list`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`" , '`seo_detail`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`" , '`permit`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`" , '`detail`' , 1);


update_exists('`'.$dbName.'`.`'.$table_Prefix."sql_log`" , '`url`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."sql_log`" , '`os`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."sql_log`" , '`browser`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."sql_log`" , '`resolution`' , 1);


//更新unid（超长的特征码数据指纹）
update_exists('`'.$dbName.'`.`'.$table_Prefix."banner_term`" , '`unid`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."banner_contact`" , '`unid`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."detail`" , '`unid`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."link`" , '`unid`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."plate`" , '`unid`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."site`" , '`unid`' , 1);
update_exists('`'.$dbName.'`.`'.$table_Prefix."term`" , '`unid`' , 1);






//检查表格是否存在，不存在则插入

if(!check_table_is_exist($dbName,$table_Prefix."goods_term_relation")){

    $sql ="CREATE TABLE IF NOT EXISTS ".$table_Prefix."goods_term_relation (
  `nid` int(11) NOT NULL,
  `name` varchar(225) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(225) DEFAULT NULL,
  `modifytime` datetime DEFAULT NULL,
  `authur` varchar(225) DEFAULT NULL,
  `ip` varchar(225) DEFAULT NULL,
  `mac` varchar(225) DEFAULT NULL,
  `remark` varchar(225) DEFAULT NULL,
  `term_id` int(11) DEFAULT NULL,
  `goods_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `type` int(11) NOT NULL DEFAULT '1'
) ENGINE=MyISAM AUTO_INCREMENT=3266 DEFAULT CHARSET=utf8;";

    $query = mysql_query($sql) or die ("error:".mysql_error());

}

update_exists('`'.$dbName.'`.`'.$table_Prefix."goods_term_relation`" , '`type`' , 2);






$plate_result = mysql_query("SELECT * FROM ".$table_Prefix."plate WHERE mid = 'brand' ");

$brand_plate = mysql_fetch_assoc($plate_result);


if(!$brand_plate){
	
	$res = mysql_query("INSERT INTO ".$table_Prefix."plate 	 
	(mid,name,detail,banner_id,introduce,menu_primary_publish,url,title,keywords,description,term_public,sys_belong,page_list_num,term) 
	VALUES('brand','品牌中心','品牌中心详情' ,'brand' ,'品牌中心' ,'ture' ,'brand' ,'品牌中心' ,'品牌中心' ,'品牌中心' ,'term' ,'brand' ,'9' ,'list')");
	
}
//字段修改
mysql_query("ALTER TABLE ".$table_Prefix."detail CHANGE `introduce2` `introduce2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci");
mysql_query("ALTER TABLE ".$table_Prefix."detail CHANGE `introduce3` `introduce3` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci");
mysql_query("ALTER TABLE ".$table_Prefix."detail CHANGE `detail2` `detail2` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci");
mysql_query("ALTER TABLE ".$table_Prefix."detail CHANGE `detail3` `detail3` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci");

mysql_query("ALTER TABLE ".$table_Prefix."login_admin CHANGE `weixin_send` `weixin_send` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci");
mysql_query("ALTER TABLE ".$table_Prefix."login_admin CHANGE `system` `system` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci");
mysql_query("ALTER TABLE ".$table_Prefix."login_admin CHANGE `open_id` `open_id` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci");







?>